EMT Practice Test

1. Question Content...

---

Question1: When sharing Projects across teams which of the following is True?

Question2: Which is the best combination of functions to effectively implement a data quality project?

Question3: Users would export DQ mappings to PowerCenter for which of the following reasons? Choose all that apply.

Question4: What types of profiling can be performed in the Developer Tool in Data Quality?

Question5: What is the best approach to implementing Address Validation in version 9.1?

Question6: How much data can DQA handle?

Question7: Which of the following options is TRUE? The Advanced Import Wizard differs from the Basic in that

Question8: You want to derive the gender from a firstname, how would you do this?

Question9: Which two IDQ transformations can use parameters? Choose 2 answers

Question10: A customer has provided a number of delimited flat files that require profiling, but not filedefinition. What should you do first?

Question11: Which of the following is NOT a required step for using DQ for Excel?

Question12: When using field matching which is the best approach if using First Name as a match field?

Question13: The Pattern Parser is used in conjunction with which transformation?

Question14: What functionality does Data Quality Assistant provide? Choose 2 answers

Question15: IDQ parameters can be defined at what levels? Choose all that apply.

Question16: When applying a reference table in the Labeler in token mode which of the following statementsis correct?

Question17: Which parameter function is supported in IDQ 9.1?

Question18: What happens to the records when corrections are made and a status of Accept is assigned?

Question19: Which of the following is not true when it comes to creating and updating Reference Tables?

Question20: What is the primary purpose of grouping data?

Question21: When importing a flat file into a project. Developer and Analyst Tool work exactly the same

Question22: Select the transformation that will not allow a DQ mapplet to validate as a rule in version 9.1.

Question23: A customer wants to be able to review data on the overall quality of each record, which technique should be used?

Question24: When changes are made to a mapplet in IDQ 9.1 that has been integrated into PowerCenter, howare those changes propagated to the integrated mapplet?

Question25: Which Informatica option provides solutions to common data quality issues in a country, region,or industry?
Choose 1 answer.

Question26: Which transformations can be used in DQ for Excel?

Question27: If the inputs to the Edit Distance Strategy below are 'john' and NULL, what will the resultingmatch score be?

Question28: Which definition describes Column Profiling?

Question29: Which of the following is not a function of Data Standardization?

Question30: Which statements describe the Consolidation Transformation?Choose 2 answers

Question31: Where does Scorecarding fit into the data quality process?

Question32: When matching, is it always necessary to group data?

Question33: What Address Validator output field should you use to determine the quality of addressvalidated?

Question34: What Data Quality Transformation utilizes Identity populations?

Question35: When is sampling for Profiling a good idea? Select the best answer.

Question36: How is Accelerator content installed?

Question37: Should data be standardized before it reaches the Address Validator?

Question38: Which is true with regard to Profiles?

Question39: Which phrase best describes how organizations should view their approach to data quality?

Question40: Accelerators provide which of the following? Choose 4 answers

Question41: Which of the following will Impact the total amount of time it takes to execute a column profiling process?

Question42: Which two are index key levels in Identity Matching? Choose 2 answers